set hive.exec.dynamic.partition=true;
set hive.exec.dynamic.partition.mode='nonstrict';
set hive.exec.max.dynamic.partitions=400;
set hive.exec.max.dynamic.partitions.pernode=400;

insert overwrite table jms_dim.dim_sqs_global_work_time_dt
select
id
,provider_name
,provider_code
,start_time
,end_time
,dt
from jms_ods.sqs_global_work_time
where dt='{{ execution_date | cst_ds }}'
;